Defining Amazon RDS for SQL server database settings

Set the following for the Amazon RDS for SQL Server database(s) that you are using as a source:

Set the Recovery model to Bulk logged or Full. In this mode, the transaction Log is more durable and truncation occurs less frequently.
Ensure that there is a full database backup for each Amazon RDS for SQL Server database that you are using as a source.
When creating a connection string, it is possible to use any parameter supported by Amazon RDS for SQL Server. The Amazon RDS for SQL Server system administrator must ensure that the Amazon RDS for SQL Server instance is configured correctly so that the proper authentication credentials are accepted.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!